﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="offer.aspx.cs" Inherits="聚欣订单分析.offer" %>

<%@ Register Assembly="DevExpress.Web.v18.1, Version=18.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web" TagPrefix="dx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <dx:ASPxGridView ID="ASPxGridView1" ClientInstanceName="grid" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False"
            KeyFieldName="ID" Width="100%">
            <Columns>
                <dx:GridViewCommandColumn VisibleIndex="6" Width="50px">
                    <ClearFilterButton Visible="True">
                    </ClearFilterButton>
                    <CustomButtons>
                        <dx:GridViewCommandColumnCustomButton ID="GridViewCommandColumnCustomButton1" Text="移除">
                        </dx:GridViewCommandColumnCustomButton>
                    </CustomButtons>
                </dx:GridViewCommandColumn>
                <dx:GridViewDataTextColumn FieldName="ID" ReadOnly="True" VisibleIndex="0" Visible="false">
                    <EditFormSettings Visible="False" />
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataComboBoxColumn Caption="所属大类" FieldName="ParentID" VisibleIndex="1">
                    <EditFormSettings Visible="False" />
                    <PropertiesComboBox TextField="TypeName" ValueField="ID" DataSourceID="SqlDataSource2">
                    </PropertiesComboBox>
                </dx:GridViewDataComboBoxColumn>
                <dx:GridViewDataComboBoxColumn Caption="所属小类" FieldName="TypeID" VisibleIndex="2">
                    <EditFormSettings Visible="False" />
                    <PropertiesComboBox TextField="TypeName" ValueField="ID" DataSourceID="SqlDataSource2">
                    </PropertiesComboBox>
                </dx:GridViewDataComboBoxColumn>
                <dx:GridViewDataTextColumn Caption="名称" FieldName="ProName" VisibleIndex="3">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataSpinEditColumn Caption="价格" FieldName="ProMoney" VisibleIndex="4">
                    <PropertiesSpinEdit DecimalPlaces="2" DisplayFormatString="g">
                    </PropertiesSpinEdit>
                </dx:GridViewDataSpinEditColumn>
                <dx:GridViewDataMemoColumn Caption="描述" FieldName="ProRemarks" VisibleIndex="5">
                </dx:GridViewDataMemoColumn>
            </Columns>
            <Settings ShowFilterRow="True" ShowGroupPanel="True" />
        </dx:ASPxGridView>
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:JXDDConnectionString %>"
        SelectCommand="SELECT * FROM [v_tempOffer] where userID=1"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:JXDDConnectionString %>"
        SelectCommand="SELECT * FROM [tbl_epType]"></asp:SqlDataSource>
    </form>
</body>
</html>
